EDA

Brought to you by YData

Dataset statistics

Number of variables	16
Number of observations	15234
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.4 MiB
Average record size in memory	511.4 B

Variable types

Numeric	10
Text	3
Categorical	2
DateTime	1

Alerts

`host_id` is highly overall correlated with `id`	High correlation
`id` is highly overall correlated with `host_id`	High correlation
`latitude` is highly overall correlated with `neighbourhood_group`	High correlation
`longitude` is highly overall correlated with `neighbourhood_group`	High correlation
`neighbourhood_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`price` is highly overall correlated with `room_type`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`room_type` is highly overall correlated with `price`	High correlation
`minimum_nights` is highly skewed (γ1 = 33.03410305)	Skewed
`id` has unique values	Unique
`availability_365` has 5073 (33.3%) zeros	Zeros

Reproduction

Analysis started	2025-08-26 18:25:21.110295
Analysis finished	2025-08-26 18:25:26.786443
Duration	5.68 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

id
Real number (ℝ)

High correlation Unique

Distinct	15234
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17945618

Minimum	2539
Maximum	36442252
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	2539
5-th percentile	875407.4
Q1	8491858.5
median	18662582
Q3	27394790
95-th percentile	34302650
Maximum	36442252
Range	36439713
Interquartile range (IQR)	18902931

Descriptive statistics

Standard deviation	10701397
Coefficient of variation (CV)	0.5963237
Kurtosis	-1.2042241
Mean	17945618
Median Absolute Deviation (MAD)	9384715
Skewness	-0.0524836
Sum	2.7338354 × 10¹¹
Variance	1.145199 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9138664	1	< 0.1%
24588491	1	< 0.1%
4697809	1	< 0.1%
11652590	1	< 0.1%
1578103	1	< 0.1%
8382660	1	< 0.1%
34274062	1	< 0.1%
15314886	1	< 0.1%
22886125	1	< 0.1%
8899476	1	< 0.1%
Other values (15224)	15224	99.9%

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5803	1	< 0.1%
6090	1	< 0.1%
6848	1	< 0.1%
7801	1	< 0.1%

Value	Count	Frequency (%)
36442252	1	< 0.1%
36425863	1	< 0.1%
36411407	1	< 0.1%
36351543	1	< 0.1%
36351128	1	< 0.1%
36318560	1	< 0.1%
36309284	1	< 0.1%
36308600	1	< 0.1%
36280646	1	< 0.1%
36273046	1	< 0.1%

name
Text

Distinct	15101
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Length

Max length	98
Median length	54
Mean length	36.822108
Min length	1

Characters and Unicode

Total characters	560948
Distinct characters	453
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14999 ?
Unique (%)	98.5%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	Voted #1 Location Quintessential 1BR W Village Apt
3rd row	Spacious 1 bedroom apartment 15min from Manhattan
4th row	Big beautiful bedroom in huge Bushwick apartment
5th row	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK

Value	Count	Frequency (%)
in	5266	5.7%
room	3226	3.5%
	2516	2.7%
private	2381	2.6%
bedroom	2377	2.6%
apartment	2109	2.3%
cozy	1709	1.8%
apt	1446	1.6%
brooklyn	1349	1.5%
to	1296	1.4%
Other values (5747)	69080	74.5%

Most occurring characters

Value	Count	Frequency (%)
	78056	13.9%
e	38568	6.9%
o	38503	6.9%
t	33045	5.9%
a	32568	5.8%
r	30748	5.5%
i	29726	5.3%
n	29434	5.2%
l	16034	2.9%
m	15566	2.8%
Other values (443)	218700	39.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	560948	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	78056	13.9%
e	38568	6.9%
o	38503	6.9%
t	33045	5.9%
a	32568	5.8%
r	30748	5.5%
i	29726	5.3%
n	29434	5.2%
l	16034	2.9%
m	15566	2.8%
Other values (443)	218700	39.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	560948	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	78056	13.9%
e	38568	6.9%
o	38503	6.9%
t	33045	5.9%
a	32568	5.8%
r	30748	5.5%
i	29726	5.3%
n	29434	5.2%
l	16034	2.9%
m	15566	2.8%
Other values (443)	218700	39.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	560948	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	78056	13.9%
e	38568	6.9%
o	38503	6.9%
t	33045	5.9%
a	32568	5.8%
r	30748	5.5%
i	29726	5.3%
n	29434	5.2%
l	16034	2.9%
m	15566	2.8%
Other values (443)	218700	39.0%

host_id
Real number (ℝ)

High correlation

Distinct	13242
Distinct (%)	86.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63388582

Minimum	2571
Maximum	2.7384167 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	2571
5-th percentile	663838.75
Q1	6998297.2
median	28271574
Q3	98704156
95-th percentile	2.2914738 × 10⁸
Maximum	2.7384167 × 10⁸
Range	2.738391 × 10⁸
Interquartile range (IQR)	91705858

Descriptive statistics

Standard deviation	75183373
Coefficient of variation (CV)	1.1860712
Kurtosis	0.40033208
Mean	63388582
Median Absolute Deviation (MAD)	25362042
Skewness	1.2756949
Sum	9.6566166 × 10¹¹
Variance	5.6525395 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	72	0.5%
61391963	29	0.2%
16098958	21	0.1%
30283594	19	0.1%
1475015	18	0.1%
7503643	18	0.1%
137358866	18	0.1%
119669058	17	0.1%
190921808	16	0.1%
22541573	16	0.1%
Other values (13232)	14990	98.4%

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%
4396	1	< 0.1%
4869	1	< 0.1%
5089	1	< 0.1%
6041	1	< 0.1%

Value	Count	Frequency (%)
273841667	1	< 0.1%
273361532	1	< 0.1%
272872092	1	< 0.1%
272557707	1	< 0.1%
272327753	1	< 0.1%
272314085	1	< 0.1%
271901058	1	< 0.1%
271885652	1	< 0.1%
271867677	1	< 0.1%
271616449	1	< 0.1%

host_name
Text

Distinct	5480
Distinct (%)	36.0%
Missing	0
Missing (%)	0.0%
Memory size	942.3 KiB

Length

Max length	35
Median length	31
Mean length	6.11389
Min length	1

Characters and Unicode

Total characters	93139
Distinct characters	114
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3591 ?
Unique (%)	23.6%

Sample

1st row	Iris
2nd row	John
3rd row	Regan
4th row	Megan
5th row	Jenny

Value	Count	Frequency (%)
	360	2.1%
and	224	1.3%
michael	138	0.8%
david	131	0.8%
john	124	0.7%
alex	103	0.6%
laura	87	0.5%
maria	82	0.5%
sonder	81	0.5%
nyc	75	0.4%
Other values (5096)	15650	91.8%

Most occurring characters

Value	Count	Frequency (%)
a	11911	12.8%
e	8962	9.6%
i	7664	8.2%
n	7590	8.1%
r	5549	6.0%
l	4761	5.1%
o	3934	4.2%
t	2928	3.1%
s	2923	3.1%
h	2814	3.0%
Other values (104)	34103	36.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	93139	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	11911	12.8%
e	8962	9.6%
i	7664	8.2%
n	7590	8.1%
r	5549	6.0%
l	4761	5.1%
o	3934	4.2%
t	2928	3.1%
s	2923	3.1%
h	2814	3.0%
Other values (104)	34103	36.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	93139	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	11911	12.8%
e	8962	9.6%
i	7664	8.2%
n	7590	8.1%
r	5549	6.0%
l	4761	5.1%
o	3934	4.2%
t	2928	3.1%
s	2923	3.1%
h	2814	3.0%
Other values (104)	34103	36.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	93139	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	11911	12.8%
e	8962	9.6%
i	7664	8.2%
n	7590	8.1%
r	5549	6.0%
l	4761	5.1%
o	3934	4.2%
t	2928	3.1%
s	2923	3.1%
h	2814	3.0%
Other values (104)	34103	36.6%

neighbourhood_group
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	969.2 KiB

Brooklyn	6578
Manhattan	6279
Queens	1893
Bronx	346
Staten Island	138

Length

Max length	13
Median length	9
Mean length	8.1408035
Min length	5

Characters and Unicode

Total characters	124017
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Queens
4th row	Brooklyn
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Brooklyn	6578	43.2%
Manhattan	6279	41.2%
Queens	1893	12.4%
Bronx	346	2.3%
Staten Island	138	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brooklyn	6578	42.8%
manhattan	6279	40.8%
queens	1893	12.3%
bronx	346	2.3%
staten	138	0.9%
island	138	0.9%

Most occurring characters

Value	Count	Frequency (%)
n	21651	17.5%
a	19113	15.4%
o	13502	10.9%
t	12834	10.3%
r	6924	5.6%
B	6924	5.6%
l	6716	5.4%
y	6578	5.3%
k	6578	5.3%
M	6279	5.1%
Other values (10)	16918	13.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	124017	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	21651	17.5%
a	19113	15.4%
o	13502	10.9%
t	12834	10.3%
r	6924	5.6%
B	6924	5.6%
l	6716	5.4%
y	6578	5.3%
k	6578	5.3%
M	6279	5.1%
Other values (10)	16918	13.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	124017	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	21651	17.5%
a	19113	15.4%
o	13502	10.9%
t	12834	10.3%
r	6924	5.6%
B	6924	5.6%
l	6716	5.4%
y	6578	5.3%
k	6578	5.3%
M	6279	5.1%
Other values (10)	16918	13.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	124017	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	21651	17.5%
a	19113	15.4%
o	13502	10.9%
t	12834	10.3%
r	6924	5.6%
B	6924	5.6%
l	6716	5.4%
y	6578	5.3%
k	6578	5.3%
M	6279	5.1%
Other values (10)	16918	13.6%

neighbourhood
Text

Distinct	211
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

Length

Max length	26
Median length	17
Mean length	11.940659
Min length	4

Characters and Unicode

Total characters	181904
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.2%

Sample

1st row	Sunnyside
2nd row	West Village
3rd row	Astoria
4th row	Bushwick
5th row	Prospect-Lefferts Gardens

Value	Count	Frequency (%)
east	2121	8.7%
side	1378	5.6%
harlem	1300	5.3%
williamsburg	1246	5.1%
bedford-stuyvesant	1245	5.1%
heights	1156	4.7%
upper	1084	4.4%
village	954	3.9%
west	806	3.3%
bushwick	774	3.2%
Other values (224)	12455	50.8%

Most occurring characters

Value	Count	Frequency (%)
e	16604	9.1%
i	12747	7.0%
s	12671	7.0%
t	12049	6.6%
a	12028	6.6%
l	10770	5.9%
r	10669	5.9%
	9285	5.1%
n	8172	4.5%
o	7529	4.1%
Other values (44)	69380	38.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	181904	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	16604	9.1%
i	12747	7.0%
s	12671	7.0%
t	12049	6.6%
a	12028	6.6%
l	10770	5.9%
r	10669	5.9%
	9285	5.1%
n	8172	4.5%
o	7529	4.1%
Other values (44)	69380	38.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	181904	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	16604	9.1%
i	12747	7.0%
s	12671	7.0%
t	12049	6.6%
a	12028	6.6%
l	10770	5.9%
r	10669	5.9%
	9285	5.1%
n	8172	4.5%
o	7529	4.1%
Other values (44)	69380	38.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	181904	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	16604	9.1%
i	12747	7.0%
s	12671	7.0%
t	12049	6.6%
a	12028	6.6%
l	10770	5.9%
r	10669	5.9%
	9285	5.1%
n	8172	4.5%
o	7529	4.1%
Other values (44)	69380	38.1%

latitude
Real number (ℝ)

High correlation

Distinct	10443
Distinct (%)	68.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.727492

Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.643912
Q1	40.68773
median	40.72075
Q3	40.763257
95-th percentile	40.826985
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.0755275

Descriptive statistics

Standard deviation	0.05592842
Coefficient of variation (CV)	0.0013732351
Kurtosis	0.029537755
Mean	40.727492
Median Absolute Deviation (MAD)	0.036775
Skewness	0.26961298
Sum	620442.62
Variance	0.0031279882
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71813	7	< 0.1%
40.68084	7	< 0.1%
40.69414	7	< 0.1%
40.72232	7	< 0.1%
40.70732	6	< 0.1%
40.75607	6	< 0.1%
40.69054	6	< 0.1%
40.71532	6	< 0.1%
40.68237	6	< 0.1%
40.70563	6	< 0.1%
Other values (10433)	15170	99.6%

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53871	1	< 0.1%
40.54106	1	< 0.1%
40.54312	1	< 0.1%
40.5455	1	< 0.1%
40.54857	1	< 0.1%
40.54889	1	< 0.1%
40.54901	1	< 0.1%
40.55182	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.89981	1	< 0.1%
40.89811	1	< 0.1%
40.89756	1	< 0.1%
40.89747	1	< 0.1%
40.896	1	< 0.1%
40.89581	1	< 0.1%

longitude
Real number (ℝ)

High correlation

Distinct	8854
Distinct (%)	58.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.949915

Minimum	-74.23914
Maximum	-73.72582
Zeros	0
Zeros (%)	0.0%
Negative	15234
Negative (%)	100.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.003314
Q1	-73.98152
median	-73.95395
Q3	-73.93335
95-th percentile	-73.857793
Maximum	-73.72582
Range	0.51332
Interquartile range (IQR)	0.04817

Descriptive statistics

Standard deviation	0.047625463
Coefficient of variation (CV)	-0.00064402322
Kurtosis	4.6515667
Mean	-73.949915
Median Absolute Deviation (MAD)	0.024945
Skewness	1.1877173
Sum	-1126553
Variance	0.0022681847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.95742	9	0.1%
-73.94829	8	0.1%
-73.95427	8	0.1%
-73.95121	8	0.1%
-73.9398	8	0.1%
-73.95688	7	< 0.1%
-73.95149	7	< 0.1%
-73.94421	7	< 0.1%
-73.95332	7	< 0.1%
-73.95509	7	< 0.1%
Other values (8844)	15158	99.5%

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17628	1	< 0.1%
-74.17388	1	< 0.1%
-74.17117	1	< 0.1%
-74.17065	1	< 0.1%
-74.16966	1	< 0.1%
-74.16634	1	< 0.1%

Value	Count	Frequency (%)
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72778	1	< 0.1%
-73.72817	1	< 0.1%
-73.72901	1	< 0.1%
-73.72928	1	< 0.1%
-73.72931	1	< 0.1%
-73.72943	1	< 0.1%
-73.72956	1	< 0.1%
-73.72982	1	< 0.1%

room_type
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

Entire home/apt	7756
Private room	7159
Shared room	319

Length

Max length	15
Median length	15
Mean length	13.506433
Min length	11

Characters and Unicode

Total characters	205757
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Private room
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	7756	50.9%
Private room	7159	47.0%
Shared room	319	2.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	7756	25.5%
home/apt	7756	25.5%
room	7478	24.5%
private	7159	23.5%
shared	319	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	22990	11.2%
o	22712	11.0%
r	22712	11.0%
t	22671	11.0%
a	15234	7.4%
	15234	7.4%
m	15234	7.4%
i	14915	7.2%
h	8075	3.9%
p	7756	3.8%
Other values (7)	38224	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	205757	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	22990	11.2%
o	22712	11.0%
r	22712	11.0%
t	22671	11.0%
a	15234	7.4%
	15234	7.4%
m	15234	7.4%
i	14915	7.2%
h	8075	3.9%
p	7756	3.8%
Other values (7)	38224	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	205757	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	22990	11.2%
o	22712	11.0%
r	22712	11.0%
t	22671	11.0%
a	15234	7.4%
	15234	7.4%
m	15234	7.4%
i	14915	7.2%
h	8075	3.9%
p	7756	3.8%
Other values (7)	38224	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	205757	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	22990	11.2%
o	22712	11.0%
r	22712	11.0%
t	22671	11.0%
a	15234	7.4%
	15234	7.4%
m	15234	7.4%
i	14915	7.2%
h	8075	3.9%
p	7756	3.8%
Other values (7)	38224	18.6%

price
Real number (ℝ)

High correlation

Distinct	301
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.15268

Minimum	10
Maximum	350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	10
5-th percentile	40
Q1	66
median	100
Q3	155
95-th percentile	255
Maximum	350
Range	340
Interquartile range (IQR)	89

Descriptive statistics

Standard deviation	69.252428
Coefficient of variation (CV)	0.57637021
Kurtosis	0.67756296
Mean	120.15268
Median Absolute Deviation (MAD)	41
Skewness	1.064435
Sum	1830406
Variance	4795.8988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	644	4.2%
100	634	4.2%
50	498	3.3%
75	454	3.0%
60	441	2.9%
200	426	2.8%
80	419	2.8%
70	393	2.6%
65	392	2.6%
120	390	2.6%
Other values (291)	10543	69.2%

Value	Count	Frequency (%)
10	3	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
16	3	< 0.1%
19	3	< 0.1%
20	10	0.1%
21	3	< 0.1%
22	6	< 0.1%
23	1	< 0.1%
24	7	< 0.1%

Value	Count	Frequency (%)
350	98	0.6%
349	13	0.1%
346	1	< 0.1%
345	9	0.1%
344	1	< 0.1%
342	1	< 0.1%
341	1	< 0.1%
340	4	< 0.1%
339	4	< 0.1%
336	1	< 0.1%

minimum_nights
Real number (ℝ)

Skewed

Distinct	66
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.8846002

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	19.096464
Coefficient of variation (CV)	3.245159
Kurtosis	1752.4487
Mean	5.8846002
Median Absolute Deviation (MAD)	1
Skewness	33.034103
Sum	89646
Variance	364.67492
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	4106	27.0%
1	3892	25.5%
3	2647	17.4%
4	1043	6.8%
5	923	6.1%
30	909	6.0%
7	588	3.9%
6	240	1.6%
14	142	0.9%
10	135	0.9%
Other values (56)	609	4.0%

Value	Count	Frequency (%)
1	3892	25.5%
2	4106	27.0%
3	2647	17.4%
4	1043	6.8%
5	923	6.1%
6	240	1.6%
7	588	3.9%
8	42	0.3%
9	25	0.2%
10	135	0.9%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	1	< 0.1%
370	1	< 0.1%
365	8	0.1%
364	1	< 0.1%
240	1	< 0.1%
200	1	< 0.1%
198	1	< 0.1%
180	9	0.1%
160	1	< 0.1%

number_of_reviews
Real number (ℝ)

High correlation

Distinct	320
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.65531

Minimum	1
Maximum	607
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	10
Q3	33
95-th percentile	131
Maximum	607
Range	606
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	49.044845
Coefficient of variation (CV)	1.6538301
Kurtosis	16.13148
Mean	29.65531
Median Absolute Deviation (MAD)	8
Skewness	3.3557735
Sum	451769
Variance	2405.3968
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2020	13.3%
2	1342	8.8%
3	974	6.4%
4	796	5.2%
5	588	3.9%
6	543	3.6%
7	495	3.2%
8	449	2.9%
9	383	2.5%
10	330	2.2%
Other values (310)	7314	48.0%

Value	Count	Frequency (%)
1	2020	13.3%
2	1342	8.8%
3	974	6.4%
4	796	5.2%
5	588	3.9%
6	543	3.6%
7	495	3.2%
8	449	2.9%
9	383	2.5%
10	330	2.2%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%
467	1	< 0.1%
466	1	< 0.1%
459	1	< 0.1%
448	1	< 0.1%
441	1	< 0.1%

last_review
Date

Distinct	1494
Distinct (%)	9.8%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Minimum	2011-05-12 00:00:00
Maximum	2019-07-08 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

High correlation

Distinct	789
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3809039

Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.69
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.6898504
Coefficient of variation (CV)	1.2237277
Kurtosis	11.961705
Mean	1.3809039
Median Absolute Deviation (MAD)	0.62
Skewness	2.4361425
Sum	21036.69
Variance	2.8555944
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	360	2.4%
1	352	2.3%
0.05	333	2.2%
0.03	323	2.1%
0.04	268	1.8%
0.08	256	1.7%
0.16	244	1.6%
0.09	235	1.5%
0.06	226	1.5%
0.11	217	1.4%
Other values (779)	12420	81.5%

Value	Count	Frequency (%)
0.01	17	0.1%
0.02	360	2.4%
0.03	323	2.1%
0.04	268	1.8%
0.05	333	2.2%
0.06	226	1.5%
0.07	167	1.1%
0.08	256	1.7%
0.09	235	1.5%
0.1	191	1.3%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%
13.45	1	< 0.1%
13.42	1	< 0.1%
13.24	1	< 0.1%
13.15	1	< 0.1%
12.99	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	46
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.788762

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	9
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	24.519675
Coefficient of variation (CV)	5.1202535
Kurtosis	141.75031
Mean	4.788762
Median Absolute Deviation (MAD)	0
Skewness	11.41446
Sum	72952
Variance	601.21448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
1	9987	65.6%
2	2259	14.8%
3	988	6.5%
4	482	3.2%
5	300	2.0%
6	182	1.2%
7	135	0.9%
8	129	0.8%
9	79	0.5%
327	72	0.5%
Other values (36)	621	4.1%

Value	Count	Frequency (%)
1	9987	65.6%
2	2259	14.8%
3	988	6.5%
4	482	3.2%
5	300	2.0%
6	182	1.2%
7	135	0.9%
8	129	0.8%
9	79	0.5%
10	50	0.3%

Value	Count	Frequency (%)
327	72	0.5%
232	4	< 0.1%
121	19	0.1%
103	18	0.1%
96	30	0.2%
91	29	0.2%
87	16	0.1%
52	36	0.2%
50	15	0.1%
49	3	< 0.1%

availability_365
Real number (ℝ)

Zeros

Distinct	366
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	112.72391

Minimum	0
Maximum	365
Zeros	5073
Zeros (%)	33.3%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	51
Q3	224
95-th percentile	354
Maximum	365
Range	365
Interquartile range (IQR)	224

Descriptive statistics

Standard deviation	129.09634
Coefficient of variation (CV)	1.1452436
Kurtosis	-0.98837262
Mean	112.72391
Median Absolute Deviation (MAD)	51
Skewness	0.75240675
Sum	1717236
Variance	16665.864
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5073	33.3%
365	296	1.9%
1	156	1.0%
364	127	0.8%
5	111	0.7%
3	104	0.7%
2	100	0.7%
4	97	0.6%
6	91	0.6%
90	85	0.6%
Other values (356)	8994	59.0%

Value	Count	Frequency (%)
0	5073	33.3%
1	156	1.0%
2	100	0.7%
3	104	0.7%
4	97	0.6%
5	111	0.7%
6	91	0.6%
7	81	0.5%
8	75	0.5%
9	72	0.5%

Value	Count	Frequency (%)
365	296	1.9%
364	127	0.8%
363	65	0.4%
362	47	0.3%
361	33	0.2%
360	28	0.2%
359	40	0.3%
358	39	0.3%
357	29	0.2%
356	24	0.2%

	availability_365	calculated_host_listings_count	host_id	id	latitude	longitude	minimum_nights	neighbourhood_group	number_of_reviews	price	reviews_per_month	room_type
availability_365	1.000	0.371	0.123	0.066	-0.035	0.104	0.016	0.084	0.304	0.039	0.397	0.104
calculated_host_listings_count	0.371	1.000	0.121	0.091	-0.017	0.109	-0.005	0.064	0.088	-0.177	0.153	0.071
host_id	0.123	0.121	1.000	0.565	0.022	0.142	-0.198	0.099	-0.091	-0.123	0.272	0.105
id	0.066	0.091	0.565	1.000	-0.021	0.100	-0.168	0.060	-0.294	-0.078	0.365	0.084
latitude	-0.035	-0.017	0.022	-0.021	1.000	0.054	0.012	0.544	-0.019	0.112	-0.030	0.100
longitude	0.104	0.109	0.142	0.100	0.054	1.000	-0.125	0.653	0.065	-0.415	0.128	0.129
minimum_nights	0.016	-0.005	-0.198	-0.168	0.012	-0.125	1.000	0.000	-0.164	0.117	-0.293	0.000
neighbourhood_group	0.084	0.064	0.099	0.060	0.544	0.653	0.000	1.000	0.026	0.175	0.067	0.099
number_of_reviews	0.304	0.088	-0.091	-0.294	-0.019	0.065	-0.164	0.026	1.000	0.013	0.707	0.000
price	0.039	-0.177	-0.123	-0.078	0.112	-0.415	0.117	0.175	0.013	1.000	-0.020	0.501
reviews_per_month	0.397	0.153	0.272	0.365	-0.030	0.128	-0.293	0.067	0.707	-0.020	1.000	0.015
room_type	0.104	0.071	0.105	0.084	0.100	0.129	0.000	0.099	0.000	0.501	0.015	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
2	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
3	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
4	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
5	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
6	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
7	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
8	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64
9	18340498	Private bedroom and bathroom near Prospect Park	33723491	Suzzanne	Brooklyn	Flatbush	40.65274	-73.95848	Private room	39	2	7	2017-09-29	0.27	1	0

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
15224	26029571	Bright, spacious one bedroom in Brooklyn	7193111	Tanya	Brooklyn	Crown Heights	40.67639	-73.94714	Entire home/apt	200	1	15	2019-06-12	1.42	1	2
15225	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
15226	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
15227	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
15228	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
15229	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
15230	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
15231	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
15232	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
15233	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample